R Notebook

This is an R Markdown Notebook. When you execute code within the notebook, the results appear beneath the code.

Try executing this chunk by clicking the Run button within the chunk or by placing your cursor inside it and pressing Ctrl+Shift+Enter.

<<<<<<< HEAD

pushIndicatorGraph(fig, 395)

Loading required package: rjson
Loading required package: httr

Attaching package: 㤼㸱httr㤼㸲

The following object is masked from 㤼㸱package:plotly㤼㸲:

    config

Error in pushAplansData(body, "indicator_graph/") : 
  Bad Request (HTTP 400).

=======

tmp <- dat[dat$date>=max(dat$date)-20,]
tmp <- aggregate(tmp$new, by=tmp[c("area")], FUN=function(x) sum(x, na.rm=TRUE))
fig <- plot_ly() %>%
   add_trace(
    type="choropleth",
    geojson=geojson,
    locations=tmp$area,
    z=tmp$x,
    zmin=0,
    zmax=30,
    colorscale="Viridis",
    featureidkey="properties.Name"
  ) %>%
  layout(
    geo = g
  )
fig

>>>>>>> b4e35ca95f79ed74fb448ccd1682fc683b84c0d2

### Kartta kaikista raportoiduista tapauksista

tmp <- dat[dat$date==max(dat$date),]
fig <- plot_ly() %>%
   add_trace(
    type="choropleth",
    geojson=geojson,
    locations=tmp$area,
    z=tmp$cumulative,
    zmin=0,
    zmax=50,
    colorscale="Viridis",
    featureidkey="properties.Name"
  ) %>%
  layout(
    geo = g
  )
fig

############################################

url <- 'https://raw.githubusercontent.com/plotly/datasets/master/geojson-counties-fips.json'
counties <- rjson::fromJSON(file=url)
url2<- "https://raw.githubusercontent.com/plotly/datasets/master/fips-unemp-16.csv"
df <- read.csv(url2, colClasses=c(fips="character"))
g <- list(
  scope = 'usa',
  projection = list(type = 'albers usa'),
  showlakes = TRUE,
  lakecolor = toRGB('white')
)
fig <- plot_ly()
fig <- fig %>% add_trace(
    type="choropleth",
    geojson=counties,
    locations=df$fips,
    z=df$unemp,
    colorscale="Viridis",
    zmin=0,
    zmax=12,
    marker=list(line=list(
      width=0)
    )
  )
fig <- fig %>% colorbar(title = "Unemployment Rate (%)")
fig <- fig %>% layout(
    title = "2016 US Unemployment by County"
)

fig <- fig %>% layout(
    geo = g
  )

fig

#################################################

shp <- substr(meta[grep("SHP",meta)-1],8,13)
day <- substr(meta[grep(':"week"',meta)-2],8,13)

l1 <- "https://sampo.thl.fi/pivot/prod/fi/epirapo/covid19case/fact_epirapo_covid19case.csv?row=dateweek2020010120201231-"
l1j <- "https://sampo.thl.fi/pivot/prod/fi/epirapo/covid19case/fact_epirapo_covid19case.json?row=dateweek2020010120201231-"
l2 <- "&row=hcdmunicipality2020-"
l3 <- "&column=measure-141082"

out <- data.frame()
for(i in shp) {
   for(j in day) {
      out <- rbind(out, read.csv(paste0(l1, j, l2, i, l3),sep=";"))
   }
}
out <- data.frame()
for(i in shp) {
   for(j in "443686") {
      out <- rbind(out, read.csv(paste0(l1, j, l2, i, l3),sep=";"))
   }
}
dat <- out
dat$val <- as.numeric(as.character(dat$val))
dat <- na.omit(dat)
dat$Time <- as.numeric(substr(dat$Aika,19,20))
dat$Day <- as.Date(dat$Aika)

library(ggplot2) 
library(plotly)

plot_ly(dat[dat$Mittari=="Tapausten lukumäärä",], x=~Time, y=~val, color=~Alue, type="scatter", mode="markers&lines") %>% 
   layout(title="Tapausten lukumäärä")

ggplot(dat[dat$Mittari=="Tapausten lukumäärä" & !grepl("SHP",dat$Alue),], aes(x=Time, y=val,colour=Alue))+geom_line()+facet_wrap(~Mittari)

ggplot(dat[dat$Mittari=="Tapausten lukumäärä",], aes(x=Day, y=val,colour=Alue))+geom_line()+facet_wrap(~Mittari)


tmp <- data.frame(value=unlist(aineisto$dataset$value))
tmp$value <- as.numeric(tmp$value)
tmp <- rownames_to_column(tmp)

tmp <- merge(data.frame(rowname=1:prod(aineisto$dataset$dimension$size)),tmp,all=TRUE)

tmp <- matrix(tmp$value,nrow=aineisto$dataset$dimension$size[2], dimnames=list(
unlist(aineisto$dataset$dimension$hcdmunicipality2020$category$label),
unlist(aineisto$dataset$dimension$dateweek2020010120201231$category$label)
))

#puretaan kategoriat paloiksi
 tmp <- aineisto$dataset$dimension$dateweek2020010120201231$category
 label <- data.frame(
   label=unlist(tmp$label),
   index=unlist(tmp$index),
   labelname=unlist(names(tmp$label)),
   indexname=unlist(names(tmp$label))
  )
  
 #Nimetään palaset
 names(label)<-"label"
 names(index)<-"index"
  
 #Laitetana vielä rivinumerot sarakkeiksi, jotta nämä saadaan yhteen.
 label<-rownames_to_column(label)
 index<-rownames_to_column(index)
  
 #Yhdistetään rivinimeä käyttäen
 kategoriat <- index %>% left_join(label,by="rowname")
 
 #otetaan data
 data <- as.data.frame(unlist(aineisto$dataset$value))
 
 #Nimetään
 names(data)<-"Tapauksien lkm"
 data<-rownames_to_column(data)
 data$rowname<-as.numeric(data$rowname)
 
#Yhdistetään muuhun aineistoon
 dataset <- kategoriat %>% left_join(data,by=c("index"="rowname"))

Add a new chunk by clicking the Insert Chunk button on the toolbar or by pressing Ctrl+Alt+I.

When you save the notebook, an HTML file containing the code and output will be saved alongside it (click the Preview button or press Ctrl+Shift+K to preview the HTML file).

The preview shows you a rendered HTML copy of the contents of the editor. Consequently, unlike Knit, Preview does not run any R code chunks. Instead, the output of the chunk when it was last run in the editor is displayed.

<<<<<<< HEAD ======= >>>>>>> b4e35ca95f79ed74fb448ccd1682fc683b84c0d2